<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="fx143896">pg_amproc</title>
  <body>
    <p>The <codeph>pg_amproc</codeph> table stores information about support procedures associated with
      index access method operator classes. There is one row for each support procedure belonging to
      an operator class.</p>
    <table id="fx143898">
      <title>pg_catalog.pg_amproc</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="131pt"/>
        <colspec colnum="2" colname="col2" colwidth="86pt"/>
        <colspec colnum="3" colname="col3" colwidth="85pt"/>
        <colspec colnum="4" colname="col4" colwidth="147pt"/>
        <thead>
          <row><entry colname="col1">column</entry><entry colname="col2">type</entry><entry colname="col3">references</entry><entry colname="col4">description</entry></row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1"><codeph>oid</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3"></entry>
            <entry colname="col4">Row identifier (hidden attribute; must be explicitly selected)</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>amprocfamily</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_opfamily.oid</entry>
            <entry colname="col4">The operator family this entry is for</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>amproclefttype</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_type.oid</entry>
            <entry colname="col4">Left-hand input data type of associated operator</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>amprocrighttype</codeph></entry>
            <entry colname="col2">oid</entry>
            <entry colname="col3">pg_type.oid</entry>
            <entry colname="col4">Right-hand input data type of associated operator</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>amprocnum</codeph></entry>
            <entry colname="col2">int2</entry>
            <entry colname="col3"/><entry colname="col4">Support procedure number</entry>
          </row>
          <row>
            <entry colname="col1"><codeph>amproc</codeph></entry>
            <entry colname="col2">regproc</entry>
            <entry colname="col3">pg_proc.oid</entry><entry colname="col4">OID of the procedure</entry>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>

